Hello Everyone,We are working with Amazon as a vendor. They will send us a bill for X amount, let’s say $1000. They will also let us apply credits to that bill, let’s say for $200. We want to pay $800 but we also want to show the full $1000 on the bank rec.When I create a bill for $1000 and then a debit adjustment for $200, I only see $800 on my reconciliation statements. Is there a way around this to apply the $200 credit to also see it on the statement?Thanks
Hello Everyone,I am working on a form in report designer that needs to exactly match a PDF form. I converted the PDF to PNG and brought it into my report as a picture box and it matches perfectly. However I need to add datafields on top. My question: is it possible to lay datafields on top of a picture box and get them to display? I know that I can use a panel with a background image but it does not match what I need to do exactly. Is there anyway to do this with a picture box or will I have to use the panel?Thanks
Hello, I would like to be able to reprint an employee’s pay stub after the paycheck has already been released. Is there a way to do this? When I go to the Pay Stubs screen, it’s blank.
Hello everyone,The bank we are working with requires a Batch Sequence letter. For example, if there were 5 batches exported and uploaded to their ACH portal, the first batch would have letter A, the second letter B etc. The catch is it resets every day, thus the next day if there are 6 batches, the first batch would upload again with letter A.We are using the standard Export PR Payment to ACH scenario with ACHExportProviderDL. My thoughts are to add another field to the schema which would represent the one character. The problem I am having trouble with is getting a formula to look at both the date and the batch sequence for that date. Does this seem possible to do?Thanks
Hello everyone, I am in the process of creating a generic inquiry that shows an inventory valuation by date. The reports that are pre-built with Acumatica only show by financial period. The most important column is the quantity on hand (which is used to calculate the value of the inventory).Here are my joins: Most of my joins are on inventoryID or siteID.For quantity on hand I am using this:[INLocationStatus.QtyOnHand]The problem is that the quantity on hand that I am picking up is simply the latest quantity on hand, rather than the quantity on hand as of the date chosen in the parameter: Does this seem to be a conditions/parameter issue? I am in the process of testing with trial and error on the conditions and parameters. Maybe there is another table I should use for qty on hand? Thank you all for any input.
Hello everyone,I am dealing with a peculiar issue with closing the fixed assets financial periods. To give some background, I was reconciling some new assets and I needed to open some old periods for the reconcile+ transactions to be in the right period. When I tried to close the periods again the system gave me an error stating that I had a bunch of unreleased fixed asset transactions. The assets in question are all fully depreciated assets that were brought in at the go-live with the “update gl” checkbox de-selected. Now I am stuck with this module being open all the way back to 10-2020. Has anyone come across this issue before? There are no transactions to release on Release FA Transactions FA503000. Thanks
Hello Everyone, I am working on a minor edit to my pick list form to print out kit items below items that are kits. I can get the subreport to pass-through just fine when I run the report from SO644000, the pick list screen, by picking the shipment number. When I try to run the Pick List report from the actions dropdown on SO302000, Shipments, and go to Actions → Print Pick list, the subreport does not print on the report.I wonder if this has anything to do with automation steps. Has anyone had this issue before?I am having trouble uploading an rpx file here so here are some screenshots:
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.