Sage X3

Welcome to the Sage X3 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 from around the globe.

Some stock movements still need to be posted

Posted By Ancient Nutrition over 5 years ago

I am getting the following error on the CLOPER REPORT:

I am doing the following on SQL

select distinCt IPTDAT_0, VCRNUMORI_0, * FROM PROD.STOJOU where AGGIFAFLG_0 = 1 AND IPTDAT_0 <= '01/31/2018'

I get 25 results. What do I need to do from this point to get rid of this error.

0 pnightingale over 5 years ago
Hi,

Is the Stock Status = Open for January so that you can post the stock related transactions?

Do you receive any errors when you run the accounting interface?

You mentioned that you have identified 25 transactions that are problems. Are these January 2018 or before? If before, you may need to have additional periods set to open. You may have to look at each one of these separately or you may resolve one which clears up some of or all of the rest

I would suggest contacting your local support team or your business partner.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ancient Nutrition over 5 years ago in reply to pnightingale

For the month of Dec nothing comes up.

I am trying to close the month of JAN 2018. I am getting 25 rows in return.

When I go to WIP POSTING, its just flashing and nothing happens.

The period is also open for stock.

When I run the accounting interface,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Some stock movements still need to be posted

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING