Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Date item last sold or issued?

Posted By nbirkes over 8 years ago

In MAS 200 v4.5 I am trying to find the date that an item was last sold or issued.

I can tell the last period an item was sold or issued in IM_ItemWhseHistoryByPeriod, but I was looking for something more specific.

0 jnelsonut over 8 years ago

CI_Item has a date last sold field.

Joe
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 8 years ago in reply to jnelsonut

Be aware that field doesn't populate for an issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nbirkes over 8 years ago in reply to TomTarget

I am aware of the date last sold field on CI_Item. An like Thomas said, that field does not work for items that are issued. We have quite a few sales kits and the issued date is really what we need to know.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 8 years ago in reply to nbirkes

You would have to run the Inventory Issue History Report in Inventory.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Date item last sold or issued?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING