Sales invoice have zero value (extended cost = 0)

(0) Share

Report

Posted on by Braw Rajab

hello,

i was reconciling my inventory to my GL and i fount out there are some invoices that does not match to any record on the GL level i searched for the document number in ( smartlist -> inventory -> inventory transactions) and saw one of them is a sales invoice and the extended price is 0 this is how it looks:

5824.Capture.PNG

and i went to the sales transaction window and this is what it looks like

3276.aa.PNG

my question is what is the issue here what could cause this problem and why there is no reference for this transaction on the GL level, because the are many other transactions with the same problem

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

Please click the multi-line display icon(upper right-hand corner of grid) and send screenshot. The inventory transaction is indicating that this was a return.

Was this reply helpful? Yes No
Braw Rajab 25 on at

Like (0)

Report

here you go sorry i didn't upload it like that i forgot

thank you

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

OK, let's try a screenshot of GoTo - Distributions. What is the item type for this part?

Was this reply helpful? Yes No
Braw Rajab 25 on at

Like (0)

Report

here is the screenshot and what do you mean by what is the item type?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

If you click on the blue arrow next to date what is the posting date?

Was this reply helpful? Yes No
Braw Rajab 25 on at

Like (0)

Report

the posting date is 9/1/2020

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

I would agree that that is a disconnect occurring here. Do you have access to SSMS? You need to examine records in the IV10200,SOP30300 and GL20000 tables. The SOP screenshots all appear to be correct. It is the inventory transactions that appear to be wrong which in turn created no records in the GL20000 table. Do you have a test company? Item Type is Cards->Inventory->Item pull up the item and on the left-hand side of the screen is Item Type.

Was this reply helpful? Yes No