Hi,
In posted items with the negative inventory with the below details is required which display the item list with the quantity which has been posted with negative inventory.
store, statement id, posted date, item id, On hand stock, posted quantity
i taken store, statement id, item id from RetailTransactionTable
where i need to take another two fields (On hand stock & posted quantity). please suggest me
Thanks.
where i need to take that two fields. please suggest me.
Thanks.
*This post is locked for comments
Hi Crispin,
Thanks your suggestion, I will try this way once and let you know.
Thanks,
Hi Crispin,
I need more clarification on that part. Because i am new to retail module, What is the relation between these tables (RetailTransationTable , RetailTransationSalestrans , inventTrans and inventSum).
Please suggest me
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156