时间戳

首页 > 解决方案 > 当我查询类型为“已售商品成本”的帐户时，如何返回 ExpenseAccountRef？

quickbooks - 当我查询类型为“已售商品成本”的帐户时，如何返回 ExpenseAccountRef？

问题描述

我目前需要另外两个必填字段来创建非库存项目：
ExpenseAccountRef.value和ExpenseAccountRef.name

我已发出 AccountType = 'Cost of Goods Sold' 的查询

Account.Id = ExpenseAccountRef.value 吗？
Account.Name = ExpenseAccount.name 吗？

将该对象中的 Account.Id 和 Account.Name 分别用于 ExpenseAccountRef.value 和 ExpenseAccountRef.name。

请求网址：

GET /v3/company/4620816365171303340/query?query=select * from Account where AccountType = 'Cost of Goods Sold'&minorversion=59

Content type:text/plain
Production Base URL:https://quickbooks.api.intuit.com
Sandbox Base URL:https://sandbox-quickbooks.api.intuit.com

询问：

select * from Account where AccountType = 
'Cost of Goods Sold'

回报：

{
 "QueryResponse": {
  "Account": [
   {
    "Name": "Cost of Goods Sold",
    "SubAccount": false,
    "FullyQualifiedName": "Cost of Goods Sold",
    "Active": true,
    "Classification": "Expense",
    "AccountType": "Cost of Goods Sold",
    "AccountSubType": "SuppliesMaterialsCogs",
    "CurrentBalance": 0,
    "CurrentBalanceWithSubAccounts": 0,
    "CurrencyRef": {
     "value": "USD",
     "name": "United States Dollar"
    },
    "domain": "QBO",
    "sparse": false,
    "Id": "80",
    "SyncToken": "0",
    "MetaData": {
     "CreateTime": "2021-05-01T10:36:04-07:00",
     "LastUpdatedTime": "2021-05-01T10:36:04-07:00"
    }
   },
   {
    "Name": "MyJobs_test",
    "SubAccount": false,
    "FullyQualifiedName": "MyJobs_test",
    "Active": true,
    "Classification": "Expense",
    "AccountType": "Cost of Goods Sold",
    "AccountSubType": "CostOfLaborCos",
    "CurrentBalance": 0,
    "CurrentBalanceWithSubAccounts": 0,
    "CurrencyRef": {
     "value": "USD",
     "name": "United States Dollar"
    },
    "domain": "QBO",
    "sparse": false,
    "Id": "91",
    "SyncToken": "0",
    "MetaData": {
     "CreateTime": "2021-07-13T14:31:01-07:00",
     "LastUpdatedTime": "2021-07-13T14:31:01-07:00"
    }
   }
  ],
  "startPosition": 1,
  "maxResults": 2
 },
 "time": "2021-07-15T13:21:57.267-07:00"
}

来自官方 Intuit 开发人员文档的 ExpenseAccountRef 的信息
 “引用用于向供应商支付此项目的费用帐户。
必须是帐户类型为已售商品成本的帐户。
查询帐户名称列表资源以确定适当的帐户对象此引用。
使用该对象中的 Account.Id 和 Account.Name 分别作为 ExpenseAccountRef.value 和 ExpenseAccountRef.name。"
https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/item#create-an-item

标签： quickbooksquickbooks-onlineintuit-partner-platformintuit

解决方案

是的，你没看错！

正如您引用的文档所说：

“使用 Account.Id ... 为 ExpenseAccountRef.value

和：

“Account.Name ... 用于 ExpenseAccountRef.name”

您在这里的问题是正确的陈述！

Account.Id = ExpenseAccountRef.value 吗？

Account.Name = ExpenseAccount.name 吗？

你回答了你自己的问题。呜呼！去你！:-)

推荐阅读