Symptom
- Fixed Asset XX is beign sold with customer invoice XYY (XX represents the Fixed Asset ID and XYZ represents the Customer Invoice ID).
- Customer invoice XYZ appears as unposted source document with the error message "No value of subtransaction company, setofbooks ABC, BO out FIA_SALES_LEDGER_ACCOUNT, BO in FIA_FIXED_ASSET" (ABC represents the Set of Books ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Closing Cockpit view.
- Go to the Source Documents subview.
- Find the Customer Invoice XZ and select it.
- Under the Messages field you can see the error message "No value of subtransaction company, setofbooks ABC, BO out FIA_SALES_LEDGER_ACCOUNT, BO in FIA_FIXED_ASSET".
Cause
A 100% discount is applied to customer invoice XYZ. The total net value of the customer invoice is 0,00 LC (LC = Local Currency).
Currently, it is not possible to retire a fixed asset's inventory material when the total net value of the customer invoice is zero.
Resolution
Reverse the existing customer invoice.
The reversal will trigger a Reversal Invoice which is going to also appear as Unposted Source Document in the General Ledger. As both, the reversal as well as the original document, appear as Unposted Source Documents, you can mark them as Irrelevant.
After this two workarounds are possible:
Option 1: Retire Inventory Material with a 100% discount by adding Inventory Materials with a Net Value above Zero:
It is possible to retire Inventory Materials with a 100% discount when the Customer Invoice also contains at least one Inventory Material with a net value above zero.
Then, the invoice credits the revenue from Sales of Asset (Gain) account for the Inventory Material with a net value above zero.
For all Inventory Materials with a 100% discount, the Revenue from sales of Asset (Loss) is debited and credited at the same time, actually posting a balance of zero.
Option 2: Scrap the Inventory Material:
- In the Fixed Asset work center go to the FixedAssets view.
- Find the Fixed Asset which is to be retired.
- Press Manual Posting and choose Individual Material Scrapping, or, if the whole Fixed Asset is to be retired, choose Complete Scrapping.
The Inventory Material/Fixed Asset is retired as well. But this time there will be no offsetting entries on the Revenue from sales of Asset account recorded.
See Also
Please also refer to the built-in document in the Help Center called 'Manual Postings in Fixed Assets'.
Keywords
Fixed Asset, 100% discount, Sale, Scrapping, Subtransaction, Setofbooks, Set of BookManual, Posting, Error, Company, FIA_FIXED_ASSET, FIA_SALES_LEDGER_ACCOUNT , KBA , SRD-FIN-FA , Fixed Assets , Problem