Invoice Numbers

[Chris Kelleher]

Symix 4.0R9
Prog 7.3c

I have a small utility that will go through Symix, find any invoice number
meeting my criteria, and re-number it. What tables do I need to search in
order to find ALL invoice numbers in the system ? I am currently looking in
inv-hdr, inv-item and, inv-stax, but it appears as though i've missed some.

Bill Warren
Database Administrator / Programmer
TREK, Inc.
(716) 798-3140

 

[Chris Kelleher]

Yes, You're missed a few. Most importantly the A/R tables.

The easiest way to get a list of where all a field is used is to run some
code like the following:

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>

for each symix._field no-lock
where _field-name = "inv-num",
first symix._file no-lock
where recid(_file) = _field._file-recid:

display
symix._file._file-name
symix._field._label
with stream-io.

end.

[/code]

This will give you a list of all tables with an inv-num field.

_______________________________________________
Jeff Smith
Single Source Systems Phone: 317-596-3000 Ext: 169
9003 Technology Dr. Fax: 317-596-3001
Fishers, IN 46038 jefsmi@singlesrc.com

 

[Chris Kelleher]

Hope this helps:

APPMT, APPMTD, APTRX, APTRXD, APTRXP, APTRXR, ARINV, ARINVD, ARPMTD, ARTRAN,
COMMDUE, COMMTRAN, FACOST, INV-HDR, INV-ITEM, INV-PRO, INV-STAX, JOURNAL, PO,
POCHG, POH, PR-COMM, PROGBILL, PROGH, SERIAL, VCH-HDR, ARDRAFTT, CUSTDRFT.

 

[Chris Kelleher]

remember though, that foreign keys may not be called "inv-num". i say "may",
because it has been a few years since i mucked with symix code. you need to
confirm, preferably from columbus; that all fields holding an invoice number
are named "inv-num" *everywhere*. otherwise you'll end up with dangling
references.

robert young
oms, inc.

 

[Chris Kelleher]

Be careful with this one Catalin. You have the Payable invoices and the
receivable numbers mixed. They are not the same.

 

[Chris Kelleher]

Does anyone know of a way to change your beginning invoice number to an older number. EX: 987555 to 200000. The system won't let you do it. If you override it in the source code what effect will it have on Symix?

Also:

Has anybody changed their invoice number to alpha numeric?

Thanks
David Siddons
dsiddons@envproduct.com

 

[Chris Kelleher]

Changing the Invoice number to alphanumeric would be quite a task given all
the tables (at least 30) that the number is stored in as an integer, as well
as the tables (journal, ledger) that use that field for both A/R and A/P
transactions (meaning you would need to make that same change to A/P) - I
wouldn't recommend it.

If you set the number back to 200000, you run the risk of colliding with old
invoice numbers at some point in the future. The user is allowed to
override the next invoice number during the invoicing run and mess up your
sequence again. You might change the code to not allow the user to override
the invoice number during invoicing.

Since the invoice number is 7 digits, you could go up to 1000000 or 2000000.

Tony Petrucciani
Single Source Systems, Inc.

 

[Chris Kelleher]

Now that I have been able to change my invoice# in symix.lasttran everything works fine except it won't let me print them. When I try to print on the ORDER INVOICING/CREDIT MEMO screen I get the message Next Invoice must be > 9921495. Is there a way to fix this without having to modify a program?

Dave

David Siddons
IT Coordinator
Environ Products Inc.
Exton, PA 19341
dsiddons@envproduct.com

 

[Chris Kelleher]

Nope. Sorry.

The logic in the invoicing program looks for both the lasttran record and
the last invoice record then sets the next available invoice number to be 1
greater than the maximum of those two records.

Mary S. Martin
LogicData - San Diego