Sales Invoices, Source Module, and Fiscal Year

Question

Hello, I've just discovered this following fact about our data and was wondering if anyone here had any knowledge of this situation. 
 
 In our SINVOICE table we have records populated by two sources; Sales (ORIMOD_0 = 5) and A/P-A/R Accounting (ORIMOD_0 =3). 
 Viewing the field FIY_0 I see that records coming from A/P-A/R Accounting correctly reflect the fiscal year (checked by looking at the year of ACCDAT_0; our fiscal year and calendar year are the same), but those coming from Sales show FIY_0 = 0. 
 Thank you for any insight.

Delamater · Accepted Answer

Hi Eliot, 
 
Be sure to include some helpful information, such as the version and patch level you are on as well so we can have some context and check for any known defects.

In your case, compare your data with the DIRINVFLG_0 flag. Here's an easy way to compare the data in SQL so you can see two records side by side.

SELECT TOP 1 FIY_0, * FROM DEMO.SINVOICE WHERE ORIMOD_0 = 5 
UNION 
SELECT TOP 1 FIY_0, * FROM DEMO.SINVOICE WHERE ORIMOD_0 = 3

I'm not sure if it's accurate or not without reviewing more, but a quick look at my data shows the FIY_0 only changes based on whether or not it is a direct invoice. I could be wrong though, I looked quickly. 
 
Hope that helps. 
Bob

jfly62 · Answer

That's right, FIY is only updated for direct invoices. Its the same for the PINVOICE table with FIY only updated where orimod = 3. 
 
Jay

Eliot Paisley · Answer

Thank you very much for the response!

Sage X3

Sales Invoices, Source Module, and Fiscal Year

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING