Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried joining on so.SALFCY = acc.FCY, I've tried joining SORDERQ -> SINVOICED -> CPTANALIN -> GACCOUNT, which returns me incorrect data. Does anyone have any recommendations on what's the best way to join SORDER to GACCOUNT?
The columns I need are GACCOUNT.ACC_0, GACCOUNT.DES_0, SORDER.BPCNAM_0, AND SORDER.BPCORD_0. For marginal sales I am using SORDER.PFMTOT_0.