Null Values in Output file

[DM1649245158]

In gamSf_factureAvoir jobs fields LibelleArticle__c, GroupeProduit__c, FamilleProduit__c, SousFamilleProduit__c are not correctly assigned. 

There is lot of null values

these datas are get from famprd , grpprd, sfamprd , table passing by cdelig table.

but cdelig is not always in the same database as factureAvoir 

GCGAM is based on annual database and a 2021 faclig can refer to à 2020 or 2019 cdelig record

can you check that cdelig is searched in the 3 annual databases for each faclig 

Thanks in Advance!!

[Anonymous]

I'm not sure you have explained this clearly enough. Can you give it another go with some clearer examples? You have to keep in mind that we don't know your system at all, so it might be a good idea to simplify the example to help us to understand.