Author Topic: Damaged goods Return  (Read 2344 times)

WillzShire

  • Member
  • *
  • Posts: 40
    • Design Data Concepts, LLC
Damaged goods Return
« on: September 28, 2014, 09:10:11 AM »
Got the Credit Memo set up and working great.
Now I need to figure out DAMAGED GOODS that are returned.
I suppose Credit Memo is part of that but the items have to not be added back to inventory
and in QB a COST entry goes in somewhere.
Can you point me to the parent ref for that?
Thank you

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: Damaged goods Return
« Reply #1 on: September 28, 2014, 10:02:53 AM »
I'm not aware of a "single Request" method for handling the return of Damaged Goods. The CreditMemo Request using the protocol you already have in place is step one. When at least one unit on that CreditMemo is Damaged, I'd create an InventoryAdjustmentAdd Request, identifying the relevant Damaged Goods or Expense account. That will adjust the Inventory correctly and show the Expense in the proper location when looking at Income Statements and Balance Sheets for the period.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

WillzShire

  • Member
  • *
  • Posts: 40
    • Design Data Concepts, LLC
Re: Damaged goods Return
« Reply #2 on: October 04, 2014, 01:57:15 PM »
Geoffrey,
Thanks for your help - working on the DAMAGED GOODS script.
Testing good all the way down to the last few lines then error:
CODE: -1000
SEVERITY: failed validation
MESSAGE: Error at InventorySiteRef
Reason: Text is not allowed in the context of element 'InventorySiteRef' according to DTD/Schema.
Expecting: ListID, FullName.
Field Value:   800003E1-1350312316

See script section attached.
Thank you
Will

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: Damaged goods Return
« Reply #3 on: October 06, 2014, 06:09:55 PM »
A couple things:

You need to address the element as "InventorySiteRef::ListID" or "InventorySiteRef::FullName", and you'll need to pass it a valid value. Your script suggests you're passing the CustomerRef::ListID, which is probably not the right value. The same issues pertain to the ClassRef in your script.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

WillzShire

  • Member
  • *
  • Posts: 40
    • Design Data Concepts, LLC
Re: Damaged goods Return
« Reply #4 on: October 12, 2014, 05:37:15 PM »
Alright I have that fixed - debugger is passing through that ok no error there.
now stuck at "QuantityAdjustment"
Here is error message:
CODE: -1000
SEVERITY: failed validation
MESSAGE: Error at QuantityAdjustment
Reason:   Text is not allowed in the context of element 'QuantityAdjustment' according to DTD/Schema.
Expecting: NewQuantity, QuantityDifference.

Field Value:   12

Thanks for your tips!!
See script snippet attached
« Last Edit: October 12, 2014, 05:41:31 PM by WillzShire »

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: Damaged goods Return
« Reply #5 on: October 19, 2014, 06:10:10 AM »
The error message's reason is misleading--QuantityAdjustment is a node, not an element. To fix the problem, delete the third Set Variable line in your script and edit the Set Variable line that follows it to "QuantityAdjustment::NewQuantity" instead of "NewQuantity".

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

WillzShire

  • Member
  • *
  • Posts: 40
    • Design Data Concepts, LLC
Re: Damaged goods Return
« Reply #6 on: October 26, 2014, 12:06:56 PM »
Great Geoffrey,
Thank you

Debbuger is passing through "QuantityAdjustment::NewQuantity
with no error now.

However,
Now I get error about not finding the record in list.
The record is there in QB, and ListID is in FM.
Invoice and sales Receipts go through for this record.

But with Damaged Goods get this error about not finding the record.

CODE: 3120
SEVERITY: Error
MESSAGE: Object "800003D8-1349104113"
specified in the request cannot be found. 
QuickBooks error message: Invalid argument. 
The specified record does not exist in the list.

Please Advise,
Thank You
Will
« Last Edit: October 26, 2014, 03:38:49 PM by WillzShire »

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: Damaged goods Return
« Reply #7 on: October 28, 2014, 07:00:36 AM »
I'm having difficulty following the sequence and expectations for each of the three scripts. Can you label them so they correspond to the names in the Perform Script steps in in the png labeled "script 1 of 3"?

The comment in script 2 says "Query if Item exists" but is not producing a Query. Adding an InventoryAdjustment for an Item identified by its FullName (and which has no impact on Inventory) would not be optimal, even if it worked as a method of retrieving a ListID. And the steps in the Else section identify nodes and elements that do not exist in the InvenotryAdjustmentAdd schema. It appears that the RqNew function should be referencing ItemInventoryAdd.

Script 3 may have a problem with the AccountRef::ListID value, unless the Contacts_::ListID field is identifying an Account in the QB Chart of Accounts.

Script 3 will have a problem with at least one of [ InventorySiteRef::ListID ; ClassRef::ListID ] because they cannot use the same value, but both point to the same field.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852
« Last Edit: October 29, 2014, 05:25:33 AM by Geoffrey Gerhard »

WillzShire

  • Member
  • *
  • Posts: 40
    • Design Data Concepts, LLC
Re: Damaged goods Return
« Reply #8 on: November 08, 2014, 11:47:17 AM »
Geoffrey,

Here are the scripts again with labels.