Invoice getting stuck in AM or Smart Office - Duplicate Inv Numbers

Accounts can report a duplicate invoice number in Access Dimensions.

If this happens it will not process the invoice, so we will have to go into SQL change the transferred column to '1'.

There are 2 parts to this issue.

1. It could get stuck in AM - This usually occurs if there is no Account/Nominal ID against an invoice.

If we look at AMWEST DB and go to ACCOS02 table

Look at TACCSTATE collumn.

If this column is '0' that means the invoice is stuck at AM level and hasn't come to accounts.

In this case we let finance know as they know what to do.

2. It could get stuck in the middle between smart office and access dimensions.

If TACCSTATE column is 1 this means the invoice has come to accounts but is stuck in the middle between smart office and access dimension. 

In the AM2ACCESS DB go to SalesTransactions table.

Change the transferred column to 1.

Make sure the invoice number matches to the one given and don't change the wrong invoice number.

Once this is done inform finance.

They will now have to go and add the same invoice number with a letter at the end so there are no duplicates.