I have a Batch Size that is pulling the total order quantity and resizing calculating it down to the formula amount of 180 kg batch size. I have set up a parameter for Batch Size as an option to add a custom batch size and I need help on the logic; if no Batch Size is entered into the Run Report Page then calculate the normal formula batch size. But if we add a custom batch, let's say 160 kg, then it should calculate the ingredients based upon 160 kg. I'm having a problem finding the correct operator on the IIF expression for the custom batch size.
On our Shipment Confirmation form we provide our lot numbers on stock items but on a service or non-stock item I want to hide the Lot # field to not show that doesn’t have a lot code. See below. I tried using =IIF(StkItem = FALSE, FALSE,TRUE) in the text box visual expression behavior but it does not work. Can someone let me know if I need to add something to the schema to make this work?
Is there a way to add multiple finished goods in 1 BNR? Example, I have 50 KG of product that will pack out into 2 ea. 10 KG containers/lids, 4 ea. 5 KG containers/lids, 10 ea. 1 KG containers/ lids. Each container is a different size. This will come from a single sales order and I would like to only make 1 BNR for our production order. I know I can move multiple finished goods, but would like to created then in 1 BNR.
I am getting 6 sets of labels because =[AMMTran.LotSerialNbr] is pulling sets from Packaging inventory ID’s instead of Finished Good. I am using =[AMMTran.LotSerialNbr] to pull the Lot Code from a Move that is on Hold. Attached is my Expression Editor and screen shots. Can someone assist me in an expression that will only pull 1 set of labels from Finished Good?
My report is calculating the conversion from the first line “From Unit “G” grams)” and I need help with getting my report to calculate the conversion from a specific Form Unit line (GAL). Attached is my Report Designer. What do I need to add or change to point my conversion to Gallons instead of Grams? Acumatica Item Code Conversions Report Designer Value Expression
I have attached a static form to our PO that will print with the PO on vendors that we purchase ingredients from. I created a page break on the group footer and the PO prints on the first page and the static form prints on the 2nd page but the page 1 of 1 footer in printing on the 2nd page but not the first page. And when I add multiple lines to the PO to push the PO to print on a second page Acumatioca renders 10 pages and my static form prints on several pages. I have attache images for review, and my Report Designer settings for the footers. My end goal is to print the PO first and the static form letter last, as well as adding multiple lines to push the PO to a 2nd page to only print a 2 page PO and the 3rd page is my static form. Please check out my report designer setting to see what I need to change to make this work. PO page 1 and Static form page 2Page 1 of ? should print at the bottom of every page. I do not need the page count on the static form.Top image capture of the firs
We are trying to get the Applications Lines to print on our invoice. (See below, 1,2,3,4) Then at the bottom will be the sum of Prepayments and Credits. Struggling to create a SWITCH formula or by Sorting and Grouping. Or should I create a subreport to handle this? Has anyone successfully created this in a report?
I need to be able to input a 3 decimal number (1.000) on the report page for a weight. I have set up report designer to go to 3 decimals but the input number on the report page. Is a customization required or is there another way to get 3 decimals at the input window?
In our receiving department we print out receiving labels for ingredients used in production. We normally receive Cases, Pallets, Bags….etc. and we generate an inventory bar coed label to apply to the container. On the Purchase Receipt I have 1 line item on the PO for 4.44 kg. The product is delivered in 5 separate containers 4 - 1 kg and 1 - .44 kg. I select the Line Detail in the Purchase Receipt and add my 5 containers with the lot code and quantity of each. The current bar code Inventory Label is printing from the PO Receipt Line quantity, (ex. 4.44 kg of product) How do I set this up to print a label for each line in the Line Details screen in Report Designer? See image.
We generate a new PO every 2 weeks for a non-ingredient item and I am trying to have Acumatica auto generate a PO every two weeks for our receiving team to receive to. I haven’t found any Business Event documentation or videos for PO’s. Do I need to create it with Import Scenarios? Has anyone had success creating this type of auto- recurring PO’s? Mike
How do I add a hyphen in Report Designer between 2 fields. Trying to end up with this; Address - Number. +IIf([ShippingAddress.AddressLine1]<>null,[ShippingAddress.AddressLine1]+ - +[POOrder.OrderNbr]+'{br}','')
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.