{"action":"created","issue":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/1620","repository_url":"https://api.github.com/repos/kbower/tickettest1","labels_url":"https://api.github.com/repos/kbower/tickettest1/issues/1620/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest1/issues/1620/comments","events_url":"https://api.github.com/repos/kbower/tickettest1/issues/1620/events","html_url":"https://github.com/kbower/tickettest1/issues/1620","id":196596815,"number":1620,"title":"improved transaction visibility for 3rd party payments of financed orders with transfer of liability","user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"labels":[{"id":502425682,"url":"https://api.github.com/repos/kbower/tickettest1/labels/enhancement","name":"enhancement","color":"84b6eb","default":true},{"id":502436258,"url":"https://api.github.com/repos/kbower/tickettest1/labels/isf","name":"isf","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false},"assignees":[{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/kbower/tickettest1/milestones/10","html_url":"https://github.com/kbower/tickettest1/milestone/10","labels_url":"https://api.github.com/repos/kbower/tickettest1/milestones/10/labels","id":2204671,"number":10,"title":"Sprint 20 (11-12)","description":null,"creator":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":1,"state":"open","created_at":"2016-12-19T13:47:01Z","updated_at":"2016-12-20T06:32:29Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2016-12-20T06:32:29Z","updated_at":"2016-12-20T06:32:58Z","closed_at":null,"body":"_Imported from trac ticket 1620.\nCreated by **rneville**\nOpened in trac: Apr 26, 2012, 9:44:54 AM\nLast modified in trac: Jan 7, 2013, 1:59:39 PM_\n***\nI think we are going to need something to help us with our finance company transactions. Since we transfer liability for 3rd party financing, the order balance moves to the finance company customer code, then when the payment comes in it is posted to that finance company customer code making the balance go to zero.\n \nThe problem we have with LOFT is:\n \n1-      When looking at the orders AR trans under the customers customer code you also see the AR trans done for that order even though it’s done on the 3rd party credit customer code. This displays a negative balance for the order once we get funded. The way I think we would like to see it is that the only AR trans that show for the order are the ones that are also tied to the customer that we were searching. This way the balance will not go negative and confuse people. _KB Note: the problem is the balance, not the inclusion of transactions, duplicate of #819_\n \n2-      We need a mechanism to query the finance company customer code and also query a particular order and see the AR trans that are on this side of the equation. This will show the transfer of liability from the customers customer code and also show the payment posted once we are funded from finance company. Once fully funded this balance will also go to zero.\n \nThis is all important stuff in helping research and resolve any funding or posting  issues that may have occurred. Maybe the best answer is when you pull up the customer and you are looking at the AR trans, somehow the user also has the option to see the AR trans for the finance company.\n \nIf I remember correctly , Kane’s doesn’t do the transfer of liability so they may not be having this issue but I think El Dorado does use transfer of liability. You may ask Miriam what they are doing to resolve this issue on the LOFT side. Let me know what you think.\n \nSal\n\n------\n\nHelp me understand the process of the transfer of liability...\n \n1) My assumption of how the transfer of liability works is that there's a credit applied to the order for the amount financed with a corresponding debit transaction against the 3rd party finance customer code?\n2) If so, what are the transaction codes used?\n3) When does this transaction occur? Is it something done manually or is it done automatically?\n4) Do the ar trans that hit the 3rd party customer code have the order id on them as well?\n\n----\n\n1-      Yes that is exactly what happens\n2-      DTC and DTD\n3-      It occurs when the order is finalized and it is an automatic transaction\n4-      Yes the ar trans that hit the 3rd party customer do have the order id on them\n\n----\n\nOkay, I've done some poking around, thinking and testing and here's what I think needs to happen...\n \n1) We already have a ticket open regarding the balance on finalized orders. The issue here is that we didn't want the order to look to the end-user like they have an outstanding balance if they're financed. So...what we are doing when displaying the balance is (for display purposes only, not anything permanent) adding the financed amount to the credit side of the equation..thus showing what we call the \"customer's balance\". What we want to do with this ticket is to stop adding that amount in for finalized orders so that we're showing the \"accounting balance\" on finalized orders. As I've pondered this, I've realized that this is an issue whether you transfer liability or not. For the other retailers who add payments from the 3rd party financier directly to the order have the same issue with the \"customer balance\" showing a negative balance. They just lack having to look elsewhere for all transactions. Regardless of whatever else we do, we need to get this done.\n \n2) Solving the problem of viewing transactions on the 3rd party financier customer code can be accomplished a few different ways:\n \n            a) We could add the ability to filter transactions by order id to the transaction history grid on the customer screen.\n \n            b) Provide a new screen that allows you to query arbitrary artrans records however you wish (i.e. not necessarily tied to an order or a customer or a contract, etc. -you'd have to supply all of that as query criteria)\n \n            c) Find a way to join those finance transactions so that they show up either in another tab or perhaps in the transaction history tab for the original customer but in italics and a lighter color or something. For example, if you opened the original order/customer and looked at the transactions for that order, you'd see the dollar transfers and PMTs made to the financier's code too.\n \nPros & Cons of these approaches:\n \n            2a: Easiest to implement. Doesn't solve issue of the financier's customer code potentially taking a long time to load because they have a zillion transactions against them\n \n            2b: Moderate to implement and very flexible. User can tie themselves in knots if they're not very very careful about what they're querying and what conclusions they come to as a result. For example, if they forget to include/exclude some query criteria that makes them think there is/isn't a remaining balance when the opposite is really true. Relies too much on the user \"doing it right\" for my tastes.\n \n            2c: Hardest to implement but user doesn't have to go to multiple places to get information. Might be confusing since adding up Dr and Cr if you included the \"other\" transactions wouldn't necessarily add up the order's current \"customer balance\" or \"accounting balance\".\n \nWe can discuss a bit on our call tomorrow if you'd like. Otherwise, let me know which way (2a-c) sounds the most workable / user-friendly to you.\n\n----\n\n2b sounds very similar to the OCINQ screen in GERS where you can query a customer and a specific order number and view the AR trans for that or the ICINQ screen where you can query a customer and contract number and view the AR trans for that. :\n \nCust: GEMONEY                 GEMONEY           950 FORRER BLVD               ¦\n¦GEMONEY                       800-333-1082      KETTERING       OH 45420      ¦\n¦Customer Warnings?: N  Invoice#:                 Closed Dt:                   ¦\n+------------------------------------------------------------------------------+\n¦ Invoice#       Reference               Post Date                           Mop                     Trn                         Purchase              Payment              Balance ¦\n¦ 0904005ZQKP    From: JON        08-SEP-2010                                                      DTD                        4781.23                                                   4781.23 ¦\n¦ 0904005ZQKP    0914001AJ        14-SEP-2010                       GEC                        PMT                                                        4638.27                  142.96 ¦\n¦ 0904005ZQKP                                  14-SEP-2010                      GEC                        FDC                                                         142.96                   0.00 ¦\n \n \n2c sounds good because I like not having to go to multiple places to get the info you need, but I think the way its displayed is very important not to confuse people. Having a Running Balance column I think is really important in making it easy for the user to understand. I know that means that you can’t then manipulate the spreadsheet  but I don’t think that is very useful in looking at AR trans anyway.  You currently don’t have a running balance in the LOFT screen for order AR trans and I think that would help to have one. Would it be possible that when you click on the order ID to expand the AR trans in customers that you would have a split screen like the top would be just like it is now with the exception of adding a running balance, then you would have a separator and below the separator would be the AR trans for the finance company AR trans tied to the order with its own running balance.   This would allow the user to get everything they need in the one screen.\n \nI actually think that both b&c may be usefull , but if we were going to go after one at this point, if you could do “c” the way I am describing it would be very easy for users to understand and an improvement over the 2 screens they have to use in GERS now.\n"},"comment":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/comments/268166729","html_url":"https://github.com/kbower/tickettest1/issues/1620#issuecomment-268166729","issue_url":"https://api.github.com/repos/kbower/tickettest1/issues/1620","id":268166729,"user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"created_at":"2016-12-20T06:32:58Z","updated_at":"2016-12-20T06:32:58Z","body":"_**rneville** trac comment on Jan 7, 2013, 1:59:39 PM:_\n\n(Changeset [[3525]](../commit/ff7d1bb4a493fc7e79796d08f9809ebc74bbf4d3))\n* fixes #1620 (improved transaction visibility for 3rd party payments of financed orders with transfer of liability)\n"}}
{"actor":{"display_login":"kbower"}}