Query How to quickly identify which JEs had intercompany accounts where the box “eliminate” was not ticked, aside from clicking into each JE manually to check one by one? Solution By default it is currently an enhancement to show the eliminate field in Saved Searches via 239282 To make Eliminate Intercompany Transactions available on criteria and… Continue reading Eliminate not ticked in JE
Category: Errors & Solutions
Articles related to errors and its solutions
Book specific advanced intercompany journal entry
Query We need to book intercompany je to statutory books only. The account on the JE is AP intercompany GL, however the name is greyed out and not available. Do we have to eliminate AP with book specific intercompany Solution It is currently a system limitation under enhancement 402790 Ability to tag a Customer/Vendor Record on… Continue reading Book specific advanced intercompany journal entry
Different Tax Point between subsidiaries
Query I have a question. Is there any workaround for use different tax point between subsidiaries. For Example in One World Parent: Company A Subsidiary 1: company B Subsidiary 2: company C In withholding tax> Setup Withholding tax Company B using on accrual meanwhile company C using on payment. Answer By design, withholding tax point is set on Withholding Tax Setup… Continue reading Different Tax Point between subsidiaries
Error: “Notice: (SuiteScript) Invalid Account Reference Key 1 Entity xxx” When Saving Credit Card Cash Sale
User generates Cash Sale through Credit Card by saving it but encounters the error: Notice: (SuiteScript) Invalid Account Reference Key 1 Entity xxx. Solution An inactive Bank Account was defaulted on the Payment Method selected. To resolve this: Navigate to Setup > Accounting > Accounting Lists Filters: Type: Select Payment Method Show Inactives: Enter Checkmark… Continue reading Error: “Notice: (SuiteScript) Invalid Account Reference Key 1 Entity xxx” When Saving Credit Card Cash Sale
Cannot Save Cash Sale due to AVATAX not set-up in Subsidiary
A user cannot save a Cash Sale due to AVATAX not being set-up in Subsidiary. When saving a Cash Sale, user receives an unexpected error. Solution Follow the steps below: Navigate to Setup > Accounting > Tax Codes Edit Avatax> Include Company Name in the Subsidiary for AVATAX
CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX.
Customer is encountering an error in CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX. Solution: Perform CSV Import by following the steps and field mapping below: Setup > Import/Export > Import CSV Records Import Type = Transactions Record Type = Cash Sale Data handling: Update Map the following… Continue reading CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX.
CYBER ATTACKS AND TOOLS USED IN CYBER SECURITY
The internet is the fastest-evolving foundation in daily life today. Because of these new innovations, we are unable to effectively protect our private data, and as a result, cybercrime is on the rise. Digital protection has since become a major concern. Modern advances require a high level of security, including cloud computing, e-commerce, and online… Continue reading CYBER ATTACKS AND TOOLS USED IN CYBER SECURITY
Dynamically get the last 12 months to date in Search
The key expression in the formula is: {transaction.trandate} BETWEEN TRUNC(ADD_MONTHS({today},-11), ‘Month’) AND TRUNC(ADD_MONTHS({today}, 1), ‘Month’)-1 Allow me to break it down: (A) TRUNC(ADD_MONTHS({today},-11), ‘Month’) returns the 1st day of the month, 11 months ago from today. So if today is Feb. 14, 2024, it returns Mar. 1, 2023. (B) TRUNC(ADD_MONTHS({today}, 1), ‘Month’)-1 returns the last… Continue reading Dynamically get the last 12 months to date in Search
Why is the landed cost allocated not equal to the amount specified?
Query I have a purchase order and item receipt with a single item. The landed cost set up on the item receipt: Why is the $100 not allocated to the item in full since there is only one item being receipted? How is the $65.53 calculated? The item’s weight is 400g/each. It is sold, stocked… Continue reading Why is the landed cost allocated not equal to the amount specified?
Reverse Charge tax code not working on Advanced Intercompany Journal
Query I have selected “Journal” on the plug-in implementation setup for supplementary tax. and the intercompany journal Nothing has been created from the supplementary tax Answer Upon checking, Intercompany Journals is not supported by the Custom G/L Lines Plug in. This is is listed as not supported under SuiteAnswers Id: 41503 Journal. The plug-in supports Journals… Continue reading Reverse Charge tax code not working on Advanced Intercompany Journal