Distribution

Good dayI want to sum my tax totals by Tax ID  from the DAC ARTax.I have a scenario where I have to taxes on a sales order invoice  how best can I sum them on the report by the Tax ID as per the screenshot belowIn my case for this invoice I have a tax total of 105.88, and on the invoice print out in the footer I want to split the two as per the above screenshot.I have the formula =IIf([ARTax.TaxID]='SVUS',Sum([ARTax.CuryTaxAmt]),0) for the SVUS Tax ID and =IIf([ARTax.TaxID]='SUTAXUSD',Sum([ARTax.CuryTaxAmt]),0) FOR the SUTAXUSD ,Tax ID. However on the invoice template the split is not coming out correctly what could I be missing?The computation is not coming out as desiredwhich should be:Sub Total:             542.90Less Discount        32.64Invoice Total         510.26Tax Total                 76.54Surtax Total            29.34Total                      616.14I added the ARTax table on my schema to my report design as shown below  

Has anyone figured out a way to restrict Inventory Stock Item visibility by Branch/Company?

Hi team,When receiving drop ship items, I cannot add serial#’s.We need to be able to track the serial#’s also for drop ship orders.Thank you!Monika 

When you create a PO, the Promised On date in the header transfers to any PO Lines that are added.However, if you update the Promised On date in the header, the Promised date in the PO Lines alters to the Promised On date PLUS the Item Lead Time in the Vendors tab in the Stock Item (in the example below, 7 days).Is this a setting we need to change, or a bug (as obviously the Promised On date is the date the Vendor is delivering their goods to us. It does not need a lead time adding to it)?Thanks,

I was wondering if there was a way to prevent a shipment from being created on a Sales Order that has no Ship Via and/or Shipping Terms selected? Unfortunately we have a problem with sales reps not doing due diligence to check the Shipping tab prior to creating a shipment and it creates confusion and time wastes in the warehouse when a pick ticket prints with no shipping information on it.

Hello,i would like to update a checkbox through import scenario based on some conditions.If Price class is “AMMFG” then set “Subject to Commission” checkbox to TRUE, please have a look at below screenshot and help me how to solve this.  

Hi All,We have some weird behavior currently.We are trying to adjust out expired Inventory. Receipt states QTY on Hand is Zero, yet the Lot is stating a different story:We are currently not able to released this Adjustment due to the following error which is caused by the QTY On hand on the Receipt equaling 0Any ideas if what is going on and how to resolve this?

We use Parent/Child Account relationships extensively for our Customer base.  We also use a ton of Customer part numbers as Alternate IDs for our stock items.  This is becoming very difficult to manage when we have some parents with 100 child companies. Is there a way to set an alternate ID of a part number for a Parent account, and have it be used for its child accounts?  We can’t use Global in this scenario because we need to be able to use the alternate IDs on customer facing paperwork as well.  

When using paperless picking, the pick ticket can be in one of multiple statuses - On Hold, Added to Queue, Assigned, Being Picked, Returned to Queue, Picked, Completed, or Cancelled. Is there anything similar for Pack status?

Hello, looking for a sanity check.  I can “Restrict Visibility” to a company for Vendors and customers.  However, there is not “restrict visibility” option for stock items and non-stock items correct? It seems I need to use restriction groups for this which would be very cumbersome. Am I missing any other options? Thanks,Larry

the salesperson no link to employee I don’t why happen

Hello,Would like to inquire - is there any way of calculating the Freight Cost of local carriers by the number of packages on the Sales Order?Eg. each box = $15 freight cost, if the SO is to be auto-packed in 10 boxes, the freight cost should become $150.So far, I have only been able to calculate the Freight Cost by weight (per unit) or per shipment (net) for local carriers. Whereas our carriers charge directly based on packages, not weight.

Hello Acumatica Community :) Does anyone know if setting up commissions at the order level instead of the line item level is possible? OOTB commission system assigns commissions to each item in SalesOrder. I’m not sure if I missed a setup option that would allow me to assign it at the order level. Thanks!

When I was Processing a requisition the following Error has occured Error: Inserting the 'Requisition' record raised at least one error. Please review the errors.Error: 'Creator' cannot be empty. 

Our client would like to Create a Sales Order then Select a po to link to and have all items on the PO come back onto the Sales Order.   We understand how to do this line by line.   They may have 30 line items on the PO and dont want to have to enter 30 line items on the Sales order and then link each line by line.   Is there a way to do this? 

I had learned how to create a new sale price, But I can't find the warehouse, and I can't create it. Please kindly advise and thanks for your support and helping

Is there a way to allocate inventory on a sales order as soon as the sales order is released (in open status)?

How do assign individuals as requested by in the Creating a new Requests Help says employee record, but dont see anything related to Assigning users as requestor or no roles as requestor. Question what is the setup for Internal requests

Hi All,In our legacy ERP system, we had close to 30 product categories (out of the box item grouping feature) that grouped items together for various reasons (for finished goods, product line, and for component parts, categories were created for some of the parts based on functional usage).These product categories don't share many of the attributes defined in an item class: -stock/non-stock-finished good/component/subassembly/service/expense/labor-valuation method -posting classs-lot serial class-base/sales/purchase units -cycle count code-price class -default mark for (purchasing or production).On top of this, the finished good items often can be used in multiple product lines. ------------------------------In Acumatica, I created item classes that corresponded with the existing product categories. Next, I added a second segment which attempted to summarize a homogenous set of items within the product category (finished goods, average costing, same posting class, default mark for, ser

Hi,What are the steps to configure or use the GS1 barcode in Acumatica? Any example? Thanks,EV

A number of our clients are struggling with the new credit card processing workflow, where the pre-authorized amount is a cap for capturing.  Scenario: sales order is created with the amount of $100.  Credit card is pre-authorized for $100.  There is not integration with carriers through Acumatica OR (more often) it’s an LTL order, for which there is no integration in Acumatica.  So, the freight price cannot be estimated at the time of Sales Order.  Shipment is created and confirmed.  The freight price is received either from a 3rd party app or entered manually.  Invoice is created.  The invoice is now for $100 + $20 (shipping charge).  Since the card was pre-authorized for $100, the client cannot charge $120.  There are 2 options at this point: a) void pre-auth and create a new payment for $120; b) charge $100 and create another payment for $20.The issue with the first approach is that voiding does not remove holdback from an end customer account, and if they are short on money, the s

When I am posting the SO and Statue is  Awaiting payment so, I don't know how to change it as open. If I can change it I have normal flow process. Thanks for your support and helping 

I have a customer who has been anxiously waiting for the ability to complete a 2-step transfer on the mobile app. I see now that you can actually select Transfer Receipt as on option under Purchase Receipts:However, all I seem to be able to do is create the record. I can’t find anywhere to enter the Transfer Order to receive. Help?Thanks!   

Hi Community,Could someone please assist with the following situation:I have a Sales Order for 5 items Marked for PO, Purchase to Order. I create the PO, and I increase the quantity from 5 to 50. I try to Receive these 50 into my warehouse, and I get this error. Error: IN Document has been created but failed to release with the following error: 'Error: Inserting  'Sales Order Line Split' record raised at least one error. Please review the errors. Error: 'Lot/Serial Nbr.' cannot be empty.'. Please, validate a created IN Document This is the Lot/Serial Class associated with the item: Thank you,RJ

How do we use the two-factor authentication on the mobile app? The box opens to enter a two-factor authentication code on the mobile, but no way to request the code.