HeaderSeqNumber not incrementing

[flarsen]

I have a VI job that imports workorders to Mas. Everything goes fine, invoices print correctly, balances etc. But lately when we pull up an invoice, the invoice will have extra line items on it. This happens when a Invoice number is being repeated. My question: is there a way during the import that I can increment the HeaderSeqNumber? Or is there a fixup I can do to correct the problem?

Thanks

 

[Blorf]

You mentioned work orders? I am not familiar with a sequence number for the wo module.

Either way, can you odbc to your invoice history to see the last sequence for the invoice number in question? Further, why duplicate invoice numbers?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[flarsen]

ChaZ,
The VI imports into AR_Invoices. The invoice numbers are determined by another program. Our accountant tells me there should be no problem duplicating invoice numbers. Using an ODBC connection I can see the HeaderSeqNumber is not being incremented. If this number were incremented Mas would be able to relate the different invoice lines with the correct invoice. We have some invoice numbers that have been repeated 4 times and so long as the HeaderSeqNumber is incremented, Mas shows all 4 invoices as being separate. It would appear that on the VI import Mas does not check to see if that invoice number exists. So it does not increment. Is there a way that I can have Mas automatically increment this number on the import?


Thanks,
Frank

 

[Blorf]

Sadly, I don't think so. How ever, if you can ODBC to the invoice history, you could look up outside, alter your import data, then run the import.

Thats about all I can think of.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.