Ultra PRO International may also offer gifts to valued customers for their continued support as well as for special giveaways. In cases where the promotional gift is not returned, the cost of any promotional items not returned will be deducted from the refund total.
MAGIC DRAGON INVOICE FULL
To receive a full refund on a purchase that includes promotional items, all items including the promotional gift must be returned.
MAGIC DRAGON INVOICE FREE
Ultra PRO from time to time may offer free promotional items with their products. Ultra PRO International may assess a 15% restocking fee against the customer’s account or deduct the fee from the refund amount on all returns.
Please note that any damage caused by mishandling, improper installation or product defacement will result in your return being denied and the product being returned to you. The return must be adequately packaged to protect against damage in transit. The customer is solely responsible for the return shipping of items they wish to return. The refund for the items returned will be credited back to the original payment method. Please allow five (5) business days for your return to process after being received. Please allow our customer service team 24-48 hours to provide the RMA and shipping instructions.Confirm the items returned are UNOPENED and in their original packaging.Enter your Order ID if you have it (found of your order confirmation email).Choose "Return/Refund" on the dropdown titled "What can we help with?".Enter your name and email address associated with the order.To request an RMA number, click the grey "Help" icon in the bottom right corner of this screen.Package the items either in the original shipping box, or a box best suited for the size/shape of the item.NOTE: Products that are returned open, unsellable, or without an RMA are not accepted and will be sent back to the customer and a refund will not be provided. Products were purchased from within 30 days of the claim.Products are in a new, UNOPENED, and re-sellable condition.Return Merchandise Authorization (RMA) number (instructions in procedure below).For a return to be accepted, all of the following must be included: On ln2."TRANSACTION_ID" = "xref"."APPLIED_TRANSACTION_ID"Īnd ln2."TRANSACTION_LINE_ID" = "xref"."APPLIED_TRANSACTION_LINE_ID"Īnd t2.To qualify for a return of merchandise, you must follow the return guidelines set forth in this document and request a return within 30 days from the invoice date for this policy to apply. On "t2"."TRANSACTION_ID" = "xref"."APPLIED_TRANSACTION_ID" On t1."TRANSACTION_ID" = xref."ORIGINAL_TRANSACTION_ID"Īnd ln1."TRANSACTION_LINE_ID" = xref."ORIGINAL_TRANSACTION_LINE_ID" On t1."TRANSACTION_ID" = ln1."TRANSACTION_ID"
, t2."TRANSACTION_ID" t2_tranid, t2."TRANSACTION_NUMBER" t2_trannbr, t2."TRANSACTION_TYPE" t2_trantype ,xref."AMOUNT_LINKED" Applied_Amount, xref."APPLIED_TRANSACTION_ID", xref."ORIGINAL_TRANSACTION_ID", xref."APPLIED_DATE_POSTED" "t1".TRANSACTION_ID, t1."TRANSACTION_NUMBER", t1."TRANSACTION_TYPE" So I'm not sure where to turn to at this point. It seems like this is an ODBC approach (below) to getting that information but the "transaction_links" table/view doesn't seem to be available in SuiteQL. SELECT *, NT.TranDate, NT.TranID, REPLACE( BUILTIN.DF( NT.Status ), BUILTIN.DF( NT.Type ) || \' : \' ) AS Status, NT.ForeignTotal, NT.exchangerate FROM NextTransactionLineLink AS NTLL INNER JOIN Transaction AS NT ON ( NT.ID = NTLL.NextDoc ) WHERE ( NTLL.PreviousDoc = \'2373356\' ) AND NT.Type = \'CustPymt\' ORDER BY NT.TranDate ASC I am currently using this SuiteQL query but it doesn't give me the breakdown per invoice I need: So I need to get the "amount applied to this invoice". My problem is with payments - I can get the ones related to an invoice just fine, but the "total amount" on the payment may not have fully been applied to that one invoice, it may have been spread across invoices. services/rest/record/v1/salesorder/2374577 where 2374577 is the Sales Order ID). I am able to retrieve the IDs via a SuiteQL query and can then use their respective end points to get the details (e.g. Via REST I am trying to collect Sales Orders, Purchase Orders, and Invoices to display in Salesforce for a given Opportunity in Salesforce.
Because SuiteQL uses Analytics Browser schema, it doesn't match up to a lot of NetSuite information out there, which is often in context of the direct ODBC schema.
0 kommentar(er)
