| Welcome Guest : please login to be able to post | Search | Active Topics | Log In | Register |
|
|
Rank: Member
Joined: 2/21/2012
Posts: 4
|
Hi All
I wonder if anyone could help me please? Using Sage 50 2012 and GCRM contract. I'm trying to find a way of pulling out all UNPAID Sales Invoices. Receipts are made on invoices (rather than account), but can't seem to find what params I need to pass in the URL.
Any help would be really appreciated.
All the best
Laura
|
|
Rank: Advanced Member
Joined: 10/13/2010
Posts: 117
|
Can't think of any way you could do this I'm afraid. Whilst the GCRM contract does define a receipts property on the salesInvoice resource kind this property is not currently supported by Sage 50 Accounts (the property is flagged as sme:unsupported="true" if you issue a $schema request).
|
|
Rank: Member
Joined: 2/21/2012
Posts: 4
|
Thanks Darren, I was trying include=receipts etc
Does the core SDO contract support a way of returning unpaid invoices or at least receipts?
Again, many thanks for your reply.
|
|
Rank: Member
Joined: 2/21/2012
Posts: 4
|
Still persevering with the GCRM contract and Sage 50 Accounts. I have managed to pull a list of Sales Receipts using... http://127.0.0.1:5493/sdata/accounts50/GCRM/-/TradingAccounts('cust uuid')/Receipts?format=json Does anyone know how to relate these sales receipts (customer invoice payments) to the invoice they were posted against please?
|
|
Rank: Advanced Member
Joined: 10/13/2010
Posts: 117
|
Laura Colegrove wrote:Does the core SDO contract support a way of returning unpaid invoices or at least receipts? Afraid not. In fact the SDO contract has never been officially supported and was actually discontinued with the release of Accounts 2012.
|
|
Rank: Advanced Member
Joined: 10/13/2010
Posts: 117
|
Laura Colegrove wrote:Still persevering with the GCRM contract and Sage 50 Accounts. I have managed to pull a list of Sales Receipts using... http://127.0.0.1:5493/sdata/accounts50/GCRM/-/TradingAccounts('cust uuid')/Receipts?format=json Does anyone know how to relate these sales receipts (customer invoice payments) to the invoice they were posted against please? Sorry, there's nothing on the receipt resource kind that directly relates it back to an invoice either. I can't think of any way to relate the 2 pieces of information together using the current Accounts 50 implementation of the GCRM contract.
|
|
Rank: Member
Joined: 2/21/2012
Posts: 4
|
Thanks Darren for your help.
Does any one know when receipts for invoices will be supported through the GCRM contract? Is it on the road-map? Included in Sage 50 2013??
|
|
Rank: Advanced Member
Joined: 10/13/2010
Posts: 117
|
You could submit it as a wish list item on this page: https://support.sage.co.uk/default.aspx?page=568 but there are no current plans to introduce support for the receipts property on the salesInvoice resource kind in Sage 50 Accounts I'm afraid.
|
|
Rank: Member
Joined: 1/1/2012
Posts: 15
|
Does that mean there's no plans to support posting receipts through the interface also? (Receipts is currently read-only as it's own feed, and using receipts as part of salesinvoice seems to just go in to a blackhole - after much playing with variations on code!)
|
|
Rank: Advanced Member
Joined: 10/13/2010
Posts: 117
|
Brian Mcnally wrote:Does that mean there's no plans to support posting receipts through the interface also? (Receipts is currently read-only as it's own feed, and using receipts as part of salesinvoice seems to just go in to a blackhole - after much playing with variations on code!) Correct. Unfortunately there are no current plans to enable support for POST/PUT/DELETE operations on the receipts resource kind in the Accounts 50 adapter. Again my suggestion would be to submit it as a request to the wishlist. Just to clarify, the reason why it goes "in to a black hole" if you include it in the payload when POSTing a salesInvoice is because it is flagged unsupported. Any property flagged as unsupported in the Accounts 50 adapter is simply ignored. For completeness sake I should point out that there is nothing in GCRM contract that precludes POSTing receipts, it is purely that support for it has not been implemented in the Accounts 50 adapter. However other Sage applications that implement the GCRM contract may choose to provide support. To determine if the particular application you are integrating with provides support for a particular resource kind or property you can request the instance schema (e.g. http://localhost:5493/sdata/Accounts50/GCRM/-/$schema). Anything that is not supported will have the sme:unsupported attribute set to true. Hope that helps.
|
|
|
Guest |
