-
Can the Report Builder filter memo (main) is void?
Hello everyone, I have a question regarding the General Ledger. I would like to filter transactions where the memo is not equal to "void." However, I cannot find a "memo" field available in the filter options related to transactions. Could you please advise which field name should be used instead? My objective is to…
-
Line Breaks Not Preserved in GL Report Export
Hello everyone, How can i preserve line breaks for vendor bill line description or custom fields of the text area type when exporting the General Ledger report to excel ? I’m trying to maintain formatting for readability, but the line breaks seem to be stripped out in the report output. Currently getting below result
-
Consolidated Payments GL Impact
When using the consolidated payment feature the GL impact has the parent customer name for both cash (debit)and AR (credit). If we're applying payments to the child customer invoice is there a work around that allows the customer name to match the child customer name atleast for the AR side ? Essentially I want the entry…
-
Need a workflow to create GL transaction from Invoice
I would like to create a workflow that will create a general journal entry. Here is the scenario: When an invoice is created IF a specific item is included on the invoice, I want to be able to create a journal entry that will take the total and debt and credit two accounts.
-
How will Voiding an Invoice affect the Revenue?
When I void an invoice, how will it affect the revenue or the general ledger?
-
General Ledger by Customer or vendor
I want see GL report based on customer and vendor. We need to filter the companies in the GL report. The aim is to view GL report for a particular customer or vendor. We need to see GL report for a customer/vendor. Either we need to generate GL report for a particular customer/vendor by going into the respective record or…
-
Can You Change an Item's Expense Account Per Transaction?
Hello— We are in a scenario where we use the same item for two cases: Drop-shipping the item to the customer Using the item as a component for a Work Order/Assembly Item build. However, the expense account should be different for each case: When drop-shipping the item (from a Sales Order), we want to use our Purchased…
-
Unable to edit approved journal entries
We have one of our users set up with edit level permission for journal approval, but it isn't allowing us to edit approved journal entries. The entries have not yet been posted.
-
Cumulative Translation Adjustment Elimination G/L Account not Zero
Hi All How to study Cumulative Translation Adjustment Elimination G/L Account not Zero after May 2023? Is this normal system behaviour or mistake in accounting entries? I am totally lost in Consolidation and Elimination topics. Hope you can help me improve my knowledge to next higher level. Kedalene Chong
-
Is it to possible to change the GL code on vendor bill?
Hi all!, Got 2 questions : When I do a vendor bill, the GL didn't capture the COGS account even when there is COGS account associated with the item, instead it goes to Accrual Purchases. Vendor Bill didn't captured it as COGS is only associated with Sales related because of it's nature, correct? Is there a way to change…