hi @vkumar, are there any directions or training materials on how to export a GI as a report and convert it to a Report via Report designer? i failed to find any material on Acumatica wiki or Acumatica university
@olarterachel any reason why the Exclusion cannot be done in the AP503500? this would allow for in-bulk exclusion instead of going one document at a time.
two cases come to mind when the AP team booked a QuickCheck, but you need to replace it with AP Checks because the AP bill was incurred in another period on occasion we need to rebook the Quickcheck that already split, with multiple lines in the Document Details tab, some of the lines are for negative numbers (like in a real estate settlement sheet). This would not be allowed in the reclass.
In what circumstances would you Void a cleared check? How can you void something that has already been paid out of the bank? When i rebook something in acumatica and have to replace the cleared check with something similar, but with a different account split, for example
i void cleared AP checks all the time, but I agree, it would be nice to have a restriction - which users get to void the cleared items, and which users don’t based on permissions
Kirill, I suggested creating a document of the Prepayment type on the Checks and Payments form, instead of an AP check. Unlike AP checks, prepayments can have an open balance: you can process them first, and apply to the bills later. If needed, you can print a check for a prepayment. Hope this answered your question. Olga, would you be able to explain how to apply the pre-payment check to an open AP bill later? I am not positive on the next steps.
to clarify, I agree that the way to do so would be to first create a Document of Prepayment type, then create AP Check. My question is - what prevents Acumatica to allow creation of AP Check first and AP Document second?
Kirill, If you need to process a payment before the bill, create a document of the Prepayment type. any reason why i cannot create AP Check without creating an document of Prepayment type?
thank you @Naveen B! this worked as a good workaround. will raise an Idea as well.
@Naveen B here you go, attaching the XML document
the Import scenario is a wonderful option. However, it requires one crucial step: knowing which bills to update the box 7 for. this is a sequence in our year-end procedures AP team enters a bunch of bills and pay them out throughout the year sometime mid-year or Sept-October, our AP department obtains all W-9s we make determination if a particular vendor is 1099-eligible we have to get a history of AP bills and dig through each one to see if box 7 was ticked or not (what if for first half of the year, the box was always not selected, but for the second one, the box was selected?) then the AP or accounting team has to make sure to go through each bill where box 7 wasn’t selected to manually select it. my proposal / idea suggestion is this - why not ask Acumatica to design a code to do #4 and #5 above automatically as part of the Actions menu? this is a necessary step for all 1099 filing, so i feel like this should be a natural timesaver for accountants during year-end.
thank you for that. however, it’s required to know the amount, which i don’t usually know until i open old bills. It would be fantastic if Acumatica can introduce a method to backfill box 7 without Quick Check workaround
@vkumar you are right, it’s impossible to recognize the unreconciled checks. However, it’s perfectly possible to recognized either “matched” checks or “cleared” checks. Matched disbursements - those disbursements that have been imported to Acumatica & matched with an AP bill by someone doing the “Processing” workflow. No one has finished the Processing of the cashflows to move them to the “cleared” state, but the match link has been established. Cleared disbursements - those disbursements that have been imported & processed in Acumatica. Given the above, do you believe it’s possible to enhance the cashflow forecast screen?
by chance, is there a way to tie EXISTING Vendors which used to represent one of our Branches in the older Acumatica version to the new Interbranch sales module, where each branch has a Customer & a Vendor?
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.