67
Hello! When running FA GL Posting, I see the source docs there for FAADD, FACHG, etc however the batch that gets created in GL is assigned to the FA Source Doc. Is there a way to force the Source Doc from FA to flow to GL?
Thanks
Marisol
*This post is locked for comments
I've submitted this as a product request for future releases if anyone would like to go and vote.
There should be a native option to pass the source document from subledger to general ledger. Using a tool such as Management Reporter, which can only pull from the g/l tables, we cannot build a plant, property & equipment report w/ the current setup. Management Reporter can filter on the source document dimension but if that dimension only shows 'FA', then it gets us nowhere.
Additional source documents in G/L would make MR reporting more powerful and simplify MR reporting @ the G/L level altogether.
Suggestion Here - https://experience.dynamics.com/ideas/idea/?ideaid=3df90ac1-9299-e811-b96f-0003ff68aa60
Okay Britt,
Here is something to start from, this is a data set retrieving the financial detail from the fixed asset module:
Share
Report
All responses (
Answers (
SELECT 'Work' AS TRX_Status ,
A.GLINTBTCHNUM ,
B.ASSETCLASSID ,
A.SOURCDOC ,
ISNULL(C.SDOCDSCR,'') SDOCDSCR ,
A.ACTINDX ,
ISNULL(F.ACTNUMST, '') ACTNUMST ,
ISNULL(D.ACTDESCR, '') ACTDESCR ,
A.GLINTTRXDATE ,
CASE WHEN A.AMOUNT > 0 THEN A.AMOUNT
ELSE 0
END AS Debit ,
CASE WHEN A.AMOUNT < 0 THEN A.AMOUNT * -1
ELSE 0
END AS Credit
FROM FA00905 AS A
LEFT OUTER JOIN FA00100 AS B ON A.ASSETINDEX = B.ASSETINDEX
LEFT OUTER JOIN SY00900 AS C ON A.SOURCDOC = C.SOURCDOC
LEFT OUTER JOIN GL00100 AS D ON A.ACTINDX = D.ACTINDX
LEFT OUTER JOIN GL00105 AS F ON D.ACTINDX = F.ACTINDX
UNION ALL
SELECT 'History' AS TRX_Status ,
A.GLINTBTCHNUM ,
B.ASSETCLASSID ,
A.SOURCDOC ,
ISNULL(C.SDOCDSCR,'') SDOCDSCR ,
A.GLINTACCTINDX ,
ISNULL(F.ACTNUMST, '') ACTNUMST ,
ISNULL(D.ACTDESCR, '') ACTDESCR ,
A.GLINTTRXDATE ,
CASE WHEN A.AMOUNT > 0 THEN A.AMOUNT
ELSE 0
END AS Debit ,
CASE WHEN A.AMOUNT < 0 THEN A.AMOUNT * -1
ELSE 0
END AS Credit
FROM FA00902 AS A
LEFT OUTER JOIN FA00100 AS B ON A.ASSETINDEX = B.ASSETINDEX
LEFT OUTER JOIN SY00900 AS C ON A.SOURCDOC = C.SOURCDOC
LEFT OUTER JOIN GL00100 AS D ON A.GLINTACCTINDX = D.ACTINDX
LEFT OUTER JOIN GL00105 AS F ON D.ACTINDX = F.ACTINDX
Let us know if you need any further assistance,
Better you can just open the JV created by fixed asset module in General Ledger window (Transaction-->Financial-->General) after Post to GL completed in FA. Then change the Source Document whatever you want and post the same.
Hope this helps!!!
The journal entry generated by the fixed asset module is stored in the GL module unposted, the source document field can be manually changed to other values such as FAADD.
See example below:
Are you looking for automatic ways to update the source document according to the original transaction type such as retirement, addition, depreciation ...etc ?
If you are looking for ways to automate this process, you may consider creating a customized db solution to link the GL work table with the fixed asset financial detail master (FA00902). Both tables can be linked according to the following criteria:
GL10000.REFRENCE = FA00902.GLINTBTCHNUM
The source document GL10000 is FA while the source document in FA00902 is FAxx according to the type of the transaction.
Although, I don't recommend such a customization because it is simply not essential, if you are looking for ways to distinguish the journal entries originating type. If that is what you are looking for, create a report alternatively linking the GL20000 with the FA00902 to get the original source document of each journal entry generated by the fixed asset module.
Let us know if you need any further assistance,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
