HiI need to design a QT from scratch, it’s suppose to take the format provided below in an excel sheet.Which tools in report designer should I deploy to achieve this and more specifically draw the tables? Regards
HiAm trying to configure automation schedule to prepare and email statements to my client, the statement cycle set up for all the customers in the client system is end of financial period but he wants the system to prepare and email statements by end of month(EOM), is it possible configure the same as per his demands? Regards
How can I can restrict and deny a user from creating a vendor? Which form or screen do I use?
Do Unposted or Unrealeased trasactions cause a variance in the AR and GL control accounts?
How do you confirm and be sure that AP balance is equals to GL balance and their is no variance?
When a bill is paid a batch is usually generated which reduces the vendors balance and cash account. However, when the same bill is paid in foreign currency additional accounts called rounding off gain/loss account and realized gain/loss account arises. What should be the ideal scenario in the system if for a prepayment, the payable control account is debited with amount almost equals to the one crediting rounding off gain/loss account and after reversal of this transaction the rounding off gain/loss account disappears?
If you run the AR aging report and the account details should the total amounts be the same? and again how do we view and compare the totals between the AR and GL and the balances?
How do you verify whether an automation schedule to prepare and email statements is working?
Why is the QT not picking VAT and SO is coming with VAT.Kindly advice,
What causes Discrepancy in AP and GL account?Below Discrepancies with AP and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Payable.Items marked in GREEN are GL Journals that need to be reversed Row Labels AP GL Grand Total (blank) 633,263,334.12 633,263,334.12 CHE005 1,385.29 1,026,146.72 1,027,532.01 CRO001 -11,135,600.00 -11,135,600.00 GIL001 3,032,803.84 22,211,198.21 25,244,002.05 JAM001 5,189,640.00 -2,062,640.00 3,127,000.00 NDU001 0.00 -10,795,608.00 -10,795,608.00 (blank) Grand Total 387,841,130.29 252,889,529.89 640,730,660.18
What causes Variance in AR and GL account? how can we correct such discrepancies?Below Discrepancies with AR and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Receivable.Items marked in GREEN are GL Journals that need to be reversedVariance Between AR and GL Customer Customer Name AR GL Grand Total (blank) (blank) -287,877.69 -287,877.69 AGA001 (blank) -39,399,922.38 -39,399,922.38 LAN001 LANCET LABORATORIES TANZANIA 519,130,795.22 -519,398,673.64 -267,878.42 MIL001 (blank) 1,000,000.00 1,000,000.00 Grand Total 7,496,567,071.64 -7,535,522,750.12 -38,955,678.48
Can some guide me on how to configure an automation schedule to prepare and email statement on Bi monthly basis
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.