while we have error like this picture below:
insufficient inventory transactions with status purchased
compare purchase order and invoice values
it happen because inventtrans, to check it, go to inventtrans table:
we have 2 records from this reference po number, first without location and physical date,
on reality, we already received, so we want to make the purchase invoice
this is the solution:
delete record of the first records.via aot
why we delete the first record, because, the first one status still ordered, I think this problem because of custom apps, so when the finance trying to posted the invoice, the ax calculate the inventtrans then it says insufficient with purchased
for it internal Ticket #23781
query to find:
–find the inventtransorigin recid
select * from INVENTTRANSORIGIN where REFERENCEID in (‘PO1703-000191’,
‘po1703-000196′) and DATAAREAID=’tjp’
select a.RECID,a.INVENTTRANSORIGIN,
a.INVENTDIMID, a.* from INVENTTRANS a
where
–recid from inventtransorigin
a.INVENTTRANSORIGIN in (5642583338,5642583365)
and a.DATAAREAID=’tjp’
select inventtrans with the record datefinancial 1900-01-01 00:00:00.000 and delete it