Last transaction dates/Inventory

Posted By John Bieniewicz over 5 years ago

Hi all - I'm using Microsoft Query to extract info from the system and it appears whats happening is if the item has a few bin location the data is being returned in that manner meaning I could have the same item listed a few times

Looking for a means to get the data out in a single row or one record with the last transaction date and total qty for the site in question

Thanks in advance

Parents

0 Julien Patureau over 5 years ago

Hi John, I am not sure what you are tring to achieve but look at the ITMMVT table if you want to get per product, per site, the quantity in stock (AVCBASQTY) and the last receipt / issue / count date (LASRCPDAT / LASISSDAT / LASCUNDAT).

What you can't find in this table is the last stock change / quality control date.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Julien Patureau over 5 years ago

Hi John, I am not sure what you are tring to achieve but look at the ITMMVT table if you want to get per product, per site, the quantity in stock (AVCBASQTY) and the last receipt / issue / count date (LASRCPDAT / LASISSDAT / LASCUNDAT).

What you can't find in this table is the last stock change / quality control date.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 John Bieniewicz over 5 years ago in reply to Julien Patureau

Hi, thank you for your reply, when I use LASRCPDAT & LASISSDAT I'm getting several lines per product, trying to get just one when importing into excel
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Last transaction dates/Inventory

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING